Also see common JDBC Translator Information

The JDBC ANSI translator, known by the type name jdbc-ansi, declares support for most SQL constructs supported by Teiid, except for row limit/offset and EXCEPT/INTERSECT. Translates source SQL into ANSI compliant syntax. This translator should be used when another more specific type is not available. If source exceptions arise from unsupported SQL, then consider using the JDBC Simple Translator to further restrict capabilities, or create a Custom Translator / create an enhancement request.